#! /usr/bin/env python
from sqlite3 import dbapi2 as sqlite

def drop_all():
    flist = ["Date", "First", "Second", "Third", "Fourth", "Fifth","Powerball"]

    conn = sqlite.connect("lotto-hist")
    conn.row_factory = sqlite.Row
    curs = conn.cursor()

    for i in range(1,59):
        new_table = "whiteball_" + str(i)
        skip_table = "skips_" + str(i)
        conn.execute('drop  table %s ' % (new_table) )
        conn.execute('drop table %s' %(skip_table))
    
